UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nlemPwU9PKWo8TpN9Y5kzf4tg61x0fjr6o7cFbDpmC8='
WHERE
key_id = '9338f3bd867023c328d03ec061a519b1cb6a8f9a30b9e76b240274e72933daa3'
AND (
token = 'nlemPwU9PKWo8TpN9Y5kzf4tg61x0fjr6o7cFbDpmC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)