UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0HB6P5R/lz2iyKvQWwYIw2fHFFpm8mT+SrsDdIT1ui0='
WHERE
key_id = '94396be1f484254f9c91424af79146c591f67a8a02ae93b9b8a21dcf624870f9'
AND (
token = '0HB6P5R/lz2iyKvQWwYIw2fHFFpm8mT+SrsDdIT1ui0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)