UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KiXSt5ZgyNtZ6h2TCZR2ItLCCOXWOWFU8QwRBVkgkhk='
WHERE
key_id = '34786a87bcb0375853156b837e64269d717e006837b4809a37b23f0a9869c397'
AND (
token = 'KiXSt5ZgyNtZ6h2TCZR2ItLCCOXWOWFU8QwRBVkgkhk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)