UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ABnBX9nNqnO2zuu5bxR2a0biN6R3BjZtTxLIZdvoClc='
WHERE
key_id = '7147d9a34ef669d8883c73e815d4dac02ac785c5b6907a0c8670d5862e97cff0'
AND (
token = 'ABnBX9nNqnO2zuu5bxR2a0biN6R3BjZtTxLIZdvoClc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)