UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LPnIva2AUMaujAd6yAxl1M8/0NnLTZ58L0yE036KSdc='
WHERE
key_id = 'af7451193a65ef0a756403808af5d6530563d22a003c9362f6583cae01f1ea36'
AND (
token = 'LPnIva2AUMaujAd6yAxl1M8/0NnLTZ58L0yE036KSdc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)