UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0LPAkYSsvyfCLtA1WJOIDkNWkeeahv4SkmsuRw0tg+8='
WHERE
key_id = 'e8864af8bbb6cd02ab9fefc15740c2b0a08b66cc43e3680f131301be26ef986b'
AND (
token = '0LPAkYSsvyfCLtA1WJOIDkNWkeeahv4SkmsuRw0tg+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)