UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3l7eQZdl5PjhH4k6kvrkCySSnyZYDNDl7/oe2SGoVg0='
WHERE
key_id = 'c8abc047169016996614be6a707a9bb85784fd4307dc0b67353667e3fd5bba25'
AND (
token = '3l7eQZdl5PjhH4k6kvrkCySSnyZYDNDl7/oe2SGoVg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)