UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LQzvXSJvgLrYvTmAnfwmJ7WvC2r6noQrcM71GN7zx4o='
WHERE
key_id = 'b7de63a64cac617d9ac09c2f1c81d3b56c596d89d42f45235b97bf530ee844df'
AND (
token = 'LQzvXSJvgLrYvTmAnfwmJ7WvC2r6noQrcM71GN7zx4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)