UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QR6dlStkjjsqlS48xl+99XVwyjDUuduflwEdh6juAB0='
WHERE
key_id = '92f0c1699bd16430ba76cfd0c162890edaf044027b840ef82f55e8e99b0fb830'
AND (
token = 'QR6dlStkjjsqlS48xl+99XVwyjDUuduflwEdh6juAB0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)