UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b7TiM71tOFAnDpqv98XG7V+rPmj1FMwBk/yOBKSH9tE='
WHERE
key_id = '7d220b8a7eda455c43df235f97091c97bac01ad78470dbacc2c24a4625d1a2a9'
AND (
token = 'b7TiM71tOFAnDpqv98XG7V+rPmj1FMwBk/yOBKSH9tE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)