UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UA27+LqU6JqOFh91q85b7/u+3fcPtA0XU0C6YkLP98k='
WHERE
key_id = 'e449d40e3838efd2152ce641b03e07b31ad8ae180615eec6a9e81b822dd1b9cd'
AND (
token = 'UA27+LqU6JqOFh91q85b7/u+3fcPtA0XU0C6YkLP98k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)