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