UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cNY6gn8PG4dVnnv9YD0UKKhB9c5/fZZ7Hlf/RW5xzK8='
WHERE
key_id = 'c0d02f7532143ea0cf22d446dde1248762f71ae48c7e473c224a496f51e49fbb'
AND (
token = 'cNY6gn8PG4dVnnv9YD0UKKhB9c5/fZZ7Hlf/RW5xzK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)