UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2baG0nITOcjpvVWfCGe/BQ2opq9BvEdU3j4LgV8MLAo='
WHERE
key_id = 'c00c812d4a77818fb6e505b111bb3149fc3e68035e28f54fa25145aa791630f5'
AND (
token = '2baG0nITOcjpvVWfCGe/BQ2opq9BvEdU3j4LgV8MLAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)