SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '0931d7d38c28d4f40e19b43499e4409d40f121fb85476a0a453f5acdf1b6da90' 
  AND token = 'nDBlTXCcJ0KDJUcP2id74S+6oAxb+/n88XnaZ58yeD0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00030

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}