UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H6WDMFuFIifG85diSqucOstANo7AxSQNEJTxi/iaAhs='
WHERE
key_id = '7d8041649ae9d25a3cc6578600b0d750cca2b6123558654147a79a7ba2ec0ce7'
AND (
token = 'H6WDMFuFIifG85diSqucOstANo7AxSQNEJTxi/iaAhs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)