UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ViIWNxzxq1bBeES9e5zaHyDzLccgdq6gtdQj3s4ZlkY='
WHERE
key_id = '9d949bdb7912abfe331479f8a7b314b7d69ea07ac2a3ba75360d9b577991041a'
AND (
token = 'ViIWNxzxq1bBeES9e5zaHyDzLccgdq6gtdQj3s4ZlkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)