UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bNfvfWKwlk7hbBUBxqVPGo7lPWvti5UgZpnawg+LbgE='
WHERE
key_id = 'd8afd10bfa6c5c41f0a5ccbe06ec8f82298dbe59744b267a4d523461b54ef284'
AND (
token = 'bNfvfWKwlk7hbBUBxqVPGo7lPWvti5UgZpnawg+LbgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)