UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xPfd6pBdu26U1/6N5Q26rGe40FFSlAGFOPVh7eHP8+k='
WHERE
key_id = 'e79b634512e943edd111664f75c250c607079f43309f127c6aa583dab0bb2d5d'
AND (
token = 'xPfd6pBdu26U1/6N5Q26rGe40FFSlAGFOPVh7eHP8+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)