UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hwCaTtyqkgMvHWY90jrRt6OxmiWEzYv42ad+qOgREUo='
WHERE
key_id = '3b4158a5f8212c8ce9df48f4317e7fa6d6756362198fda003cfe6a87462d4efb'
AND (
token = 'hwCaTtyqkgMvHWY90jrRt6OxmiWEzYv42ad+qOgREUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)