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