UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ofKe2sNJVYn0nJq8k1fKdlILSt0pH4GncGfUr0pG3HU='
WHERE
key_id = '31808023be6f742fd29dc492316bd731ce57381beed446e65bec1524274aedfd'
AND (
token = 'ofKe2sNJVYn0nJq8k1fKdlILSt0pH4GncGfUr0pG3HU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)