UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hUK9U7G0qazXsb/YDts7Pa4R50UTcFhf7Me8wwu90jo='
WHERE
key_id = 'c67df548109fb24578b56c3cf57e822c62d1aba40bf7362c11488e1702d8adcf'
AND (
token = 'hUK9U7G0qazXsb/YDts7Pa4R50UTcFhf7Me8wwu90jo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)