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