UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eIBTXU8vY5yuw0VCJQ6VyCD8JbrNl7rJufPS6rtZKhU='
WHERE
key_id = 'ca5a5102db702d1277558fe5c311f62866ac600327f01ab6fc3fda052235e700'
AND (
token = 'eIBTXU8vY5yuw0VCJQ6VyCD8JbrNl7rJufPS6rtZKhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)