UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QOEsvGnDizCjnC0JgcTFUGvsICeZPuMyJKMc6aEzE0Q='
WHERE
key_id = 'd3f2455840b7b746b714e0e0981e7967d153306b6565614be15f171cba736a7f'
AND (
token = 'QOEsvGnDizCjnC0JgcTFUGvsICeZPuMyJKMc6aEzE0Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)