UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kfF4LUPLQGD9aT2WLnIwx4/yTyBdGPn14YQJLHYyxj0=' 
WHERE 
  key_id = '3c616ff2180cd7e10f313f3510227a237a60ac796954d0b6be923bf4bc6c8556' 
  AND (
    token = 'kfF4LUPLQGD9aT2WLnIwx4/yTyBdGPn14YQJLHYyxj0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027