UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZhoMvi2YZf4SjCK9vrxj7XnOLxmSaPg1uoxTD31G770='
WHERE
key_id = '6a62209cd7f34dd35c5548f99ae464d51f42f3046ebdb4d56e1a0a74773ce625'
AND (
token = 'ZhoMvi2YZf4SjCK9vrxj7XnOLxmSaPg1uoxTD31G770='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)