UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QhgTVZ1E9tbBO4slp5H5vkjr4sdNH35KC3QaKofFgHM='
WHERE
key_id = '39d44e7035c755ce85b2963929edb2f31f626584e1b98417177911547fca20f4'
AND (
token = 'QhgTVZ1E9tbBO4slp5H5vkjr4sdNH35KC3QaKofFgHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)