UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7B0FVhm9RNsrfzImvsgGY4ZZHBwBZRqKPt098kMbgZE='
WHERE
key_id = '9b2501a1f5748c71f76f5b68f034b052123d7a4f5e77e60b44f1b8813aebd960'
AND (
token = '7B0FVhm9RNsrfzImvsgGY4ZZHBwBZRqKPt098kMbgZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)