UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zn7LNjDOXJ/V/EfzChn5HKDWpllz/CtW3sqw6xgLHrw='
WHERE
key_id = '42da86f56b0eabbecc1256c7e75e7b8877547b4763ad62bac0af92cbd5675690'
AND (
token = 'zn7LNjDOXJ/V/EfzChn5HKDWpllz/CtW3sqw6xgLHrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)