UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZNiuFaL3UJQJEeqvXUektlS/MQ7805OAHprxlOwWCqM='
WHERE
key_id = '6c9c646a8a527ed01f0a7b76d69be38ac843175b6edd3381fcd4392f3b9f892f'
AND (
token = 'ZNiuFaL3UJQJEeqvXUektlS/MQ7805OAHprxlOwWCqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)