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