UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '29BB4uFQt35wX7Z5eOTPZqiake4795QSeWqtmPQLBWg='
WHERE
key_id = '3a94e6a14364e4688ba8bd43faa7622b59aa11fa20769f59c644d206cde2c5c2'
AND (
token = '29BB4uFQt35wX7Z5eOTPZqiake4795QSeWqtmPQLBWg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)