UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TFQaRMjYhruaGljTV6XbWK4c8SxrUd/hHik0A7+pI50='
WHERE
key_id = 'af9f4c0d9e4f444c68d2ed663b5a923bc046cf32036d847ff5d336968c6b5d9e'
AND (
token = 'TFQaRMjYhruaGljTV6XbWK4c8SxrUd/hHik0A7+pI50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)