UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ViPF1RnbCEX/jVdNnI4gOsv0IjW4gBaVSmIESaX945w='
WHERE
key_id = 'de219bda7d022999d939b40cfa947ececac2831f3a5471d1afaf17766227d4ea'
AND (
token = 'ViPF1RnbCEX/jVdNnI4gOsv0IjW4gBaVSmIESaX945w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)