UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4dFaC7kCjZ95W85XwUIm2WqVT9yzWo9yZqreF3JEUFg='
WHERE
key_id = '99a11b5f4370afeecdd29632bd78fd9617fdf3be44752249df043f69a02b4391'
AND (
token = '4dFaC7kCjZ95W85XwUIm2WqVT9yzWo9yZqreF3JEUFg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)