UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'i526f9KNTyHXt/33qsQJXpEe6HxeUUZaEQuaTRu82JU=' 
WHERE 
  key_id = 'a93f64b6013387ad43793891e4924cc6e57cd8334b8c234ec8e503757a4f1a2b' 
  AND (
    token = 'i526f9KNTyHXt/33qsQJXpEe6HxeUUZaEQuaTRu82JU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035