UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eXvd2O2L8FkadIxsvwDPVtrkadUW9nPKgSgOqpYtjH4='
WHERE
key_id = '4978e5c0243f85bcfae92cffe5ee04c49e52a28a4b39111c7c0e0c50ebc8e311'
AND (
token = 'eXvd2O2L8FkadIxsvwDPVtrkadUW9nPKgSgOqpYtjH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)