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

Query time 0.00027