UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1dDDwWRQXLYqOgni/cb1y8K7OfjJ00UIvo71yPaoHkk=' 
WHERE 
  key_id = '7ca1e13ef3c1dfa25e3e1b647bf2a75c71ddd9cd8d0c9964d0263c4ae35fdb70' 
  AND (
    token = '1dDDwWRQXLYqOgni/cb1y8K7OfjJ00UIvo71yPaoHkk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028