UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'k7L6WFKpBI5NUs1IKbPXC7G58gBuX+9mL7rOGThZ4uc=' 
WHERE 
  key_id = 'e337fb4a7c711a7799c50b9068f8db12ec5b2afbd1f61b172bdc432f1442250a' 
  AND (
    token = 'k7L6WFKpBI5NUs1IKbPXC7G58gBuX+9mL7rOGThZ4uc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042