UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+upygwDvM76yR09MaM8zh89q1cbO5/5Nw3QCZ10v7tQ=' 
WHERE 
  key_id = 'f0b7c6d239a4f8489c22897135374f31c03a50554cb2859ef72caaa3c877070f' 
  AND (
    token = '+upygwDvM76yR09MaM8zh89q1cbO5/5Nw3QCZ10v7tQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047