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