UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0hnUKWAZEa/HFN7zoAgtcKQXsukEQpgPeqNnG1DkfwE='
WHERE
key_id = '8c1b27193d60b4cc27b2ee2fde1ab8dd66ab1a5ec451c25b2a7be7acda21ee97'
AND (
token = '0hnUKWAZEa/HFN7zoAgtcKQXsukEQpgPeqNnG1DkfwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)