UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cHzi/BsGib/tXdJ0G48fwqgEdTCHZNcCOf6zHdEyFq0='
WHERE
key_id = '9eb70c29b543a8edefb41600bcabd6259099b70e484cc247e3ac32a976233f29'
AND (
token = 'cHzi/BsGib/tXdJ0G48fwqgEdTCHZNcCOf6zHdEyFq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)